Model Table INVENTORY TURNOVER
This model dimension represents inventory turnover and is based on the IFS Cloud
fact view FACT_INVENTORY_TURNOVER. All models that refers to this dimension will
have the attributes and hierarchies as described below.
Attributes
| Attribute | Description (where applicable) |
| ADJUSTED_QTY | Indicates the adjusted quantity value. |
| CONFIGURATION_ID | This number is automatically assigned to identify a specific part configuration specification which is a unique combination of characteristics and options that is used in conjunction with a Configurable part. |
| ISSUED_QTY | Indicates the issued quantity value. |
| QTY_ONHAND | Indicates the quantity onhand value. |
| STAT_PERIOD_NO | Identifies statistic month of year. |
| STAT_YEAR_NO | The statistic year number. |
| TURNOVER_RATE | The Issued Value divided by the Average Inventory Value. |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| INVENTORY TURNOVER | FACT_INVENTORY_TURNOVER_TM | FACT_INVENTORY_TURNOVER_BI | FACT_INVENTORY_TURNOVER | Data Mart |